<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<title>zxxhouse: com.zxx.sql.sqlMan类参考</title>

<link href="tabs.css" rel="stylesheet" type="text/css"/>
<link href="doxygen.css" rel="stylesheet" type="text/css" />



</head>
<body>
<div id="top"><!-- do not remove this div! -->


<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  
  
  <td style="padding-left: 0.5em;">
   <div id="projectname">zxxhouse
   &#160;<span id="projectnumber">1.0</span>
   </div>
   
  </td>
  
  
  
 </tr>
 </tbody>
</table>
</div>

<!-- 制作者 Doxygen 1.7.6.1 -->
  <div id="navrow1" class="tabs">
    <ul class="tablist">
      <li><a href="index.html"><span>首页</span></a></li>
      <li class="current"><a href="annotated.html"><span>类</span></a></li>
      <li><a href="files.html"><span>文件</span></a></li>
    </ul>
  </div>
  <div id="navrow2" class="tabs2">
    <ul class="tablist">
      <li><a href="annotated.html"><span>组合类型列表</span></a></li>
      <li><a href="classes.html"><span>组合类型索引</span></a></li>
      <li><a href="inherits.html"><span>类继承关系</span></a></li>
      <li><a href="functions.html"><span>组合类型成员</span></a></li>
    </ul>
  </div>
  <div id="nav-path" class="navpath">
    <ul>
      <li class="navelem"><b>com</b>      </li>
      <li class="navelem"><b>zxx</b>      </li>
      <li class="navelem"><b>sql</b>      </li>
      <li class="navelem"><a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html">sqlMan</a>      </li>
    </ul>
  </div>
</div>
<div class="header">
  <div class="summary">
<a href="#pub-methods">公有成员</a> &#124;
<a href="#pub-static-methods">静态公有成员</a>  </div>
  <div class="headertitle">
<div class="title">com.zxx.sql.sqlMan类参考</div>  </div>
</div><!--header-->
<div class="contents">
<!-- doxytag: class="com::zxx::sql::sqlMan" -->
<p>数据库管理类  
 <a href="classcom_1_1zxx_1_1sql_1_1sql_man.html#details">更多...</a></p>
<div class="dynheader">
com.zxx.sql.sqlMan合作图：</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1sql_man__coll__graph.png" border="0" usemap="#com_8zxx_8sql_8sql_man_coll__map" alt="Collaboration graph"/></div>
<map name="com_8zxx_8sql_8sql_man_coll__map" id="com_8zxx_8sql_8sql_man_coll__map">
<area shape="rect" title=" sDataMan" alt="" coords="264,103,272,111"/><area shape="rect" title=" sDataMan" alt="" coords="264,135,272,143"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1house_data.html" title="搜房数据信息类" alt="" coords="5,5,205,37"/><area shape="rect" title=" mhouseData" alt="" coords="121,33,129,41"/><area shape="rect" title=" mhouseData" alt="" coords="204,103,212,111"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html" title="直接操作数据库类，sqlman调用该类" alt="" coords="229,5,472,37"/><area shape="rect" title=" mHelper" alt="" coords="332,33,340,41"/><area shape="rect" title=" mHelper" alt="" coords="251,103,259,111"/></map>
<center><span class="legend">[<a href="graph_legend.html">图例</a>]</span></center></div>

<p><a href="classcom_1_1zxx_1_1sql_1_1sql_man-members.html">所有成员的列表。</a></p>
<table class="memberdecls">
<tr><td colspan="2"><h2><a name="pub-methods"></a>
公有成员</h2></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">long&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#ade630bd22dc7fdafbcb853061b6912f1">insertData</a> ()</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">ArrayList&lt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a> &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a8220ec6e98f7f681a9e6002367fe780d">selectSQLDefault</a> (int limitindex, int limitnum)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">ArrayList&lt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a> &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a51e1619f15f11234a9b2f2e5d45138d9">selectSQLByDepart</a> (int position, int limitindex, int limitnum)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">ArrayList&lt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a> &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a08637e16cd1a288c8bb8ce20ca83e8dc">selectSQLByTotalPrice</a> (int position, int limitindex, int limitnum)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">ArrayList&lt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a> &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a2a509c26769e627d0aab9adadc276ee1">selectSQLByHouseType</a> (int position, int limitindex, int limitnum)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">ArrayList&lt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a> &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a566400e53b2720115f33ef00dfafba4a">selectSQLByZX</a> (int position, int limitindex, int limitnum)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">ArrayList&lt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a> &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#aaba0ff9f406a4804784aed9e4f97a811">selectSQLByPmPrice</a> (int position, int limitindex, int limitnum)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">ArrayList&lt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a> &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#ac4fc3535f12fcbdcfd091f6ca9b7dd1c">sort_byPriceH_L</a> (int limitindex, int limitnum)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">ArrayList&lt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a> &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a90b2775363d92c63bdc6a25f7fb13ace">sort_byPriceL_H</a> (int limitindex, int limitnum)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">ArrayList&lt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a> &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a5c98369ec30fdd33c1c3ba3b53e20bbb">sort_byYearH_L</a> (int limitindex, int limitnum)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">ArrayList&lt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a> &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a96e48378ca51ca141c468c29c5b12223">sort_byYearL_H</a> (int limitindex, int limitnum)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">ArrayList&lt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a> &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#ace45dff4a0544e8a24d0ca121ec369d0">sort_byAreaL_H</a> (int limitindex, int limitnum)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">ArrayList&lt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a> &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#af8278ce8bab519ebb5d6e909edbfa2cd">sort_byAreaH_L</a> (int limitindex, int limitnum)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a4de4fb93998425200bce9ac7d8d94385">getSqlAllRow</a> ()</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a18d6c85da0f0fd72cddd38bed00f6b83">getdepartmentAllRow</a> (int position)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a36d1520cc83a606111323bf4ae1b6c01">getTotalPriceAllrow</a> (int position)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a5e18d0bd4b1170a043a4b43f32f651f7">getHouseTypeRow</a> (int position)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#adb9f43d7a23c7db4adc2978b96c7feda">getZXTypeRow</a> (int position)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a51310f84ffa54239860ee1edb78bc8da">getPmPriceAllrow</a> (int position)</td></tr>
<tr><td colspan="2"><h2><a name="pub-static-methods"></a>
静态公有成员</h2></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static <a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html">sqlMan</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#ad59ab25ed879f94b9809f858dbbeb16d">get</a> (Context c)</td></tr>
</table>
<hr/><a name="details" id="details"></a><h2>详细描述</h2>
<div class="textblock"><p>数据库管理类 </p>
<dl class="author"><dt><b>作者:</b></dt><dd>zxx </dd></dl>

<p>在文件<a class="el" href="sql_man_8java_source.html">sqlMan.java</a>第<a class="el" href="sql_man_8java_source.html#l00020">20</a>行定义。</p>
</div><hr/><h2>成员函数文档</h2>
<a class="anchor" id="ad59ab25ed879f94b9809f858dbbeb16d"></a><!-- doxytag: member="com::zxx::sql::sqlMan::get" ref="ad59ab25ed879f94b9809f858dbbeb16d" args="(Context c)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static <a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html">sqlMan</a> <a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#ad59ab25ed879f94b9809f858dbbeb16d">com.zxx.sql.sqlMan.get</a> </td>
          <td>(</td>
          <td class="paramtype">Context&#160;</td>
          <td class="paramname"><em>c</em></td><td>)</td>
          <td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">
<p>Description:单例模式 </p>
<dl class="return"><dt><b>返回:</b></dt><dd>sqlMan单例 </dd></dl>

<p>在文件<a class="el" href="sql_man_8java_source.html">sqlMan.java</a>第<a class="el" href="sql_man_8java_source.html#l00054">54</a>行定义。</p>

</div>
</div>
<a class="anchor" id="a18d6c85da0f0fd72cddd38bed00f6b83"></a><!-- doxytag: member="com::zxx::sql::sqlMan::getdepartmentAllRow" ref="a18d6c85da0f0fd72cddd38bed00f6b83" args="(int position)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int <a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a18d6c85da0f0fd72cddd38bed00f6b83">com.zxx.sql.sqlMan.getdepartmentAllRow</a> </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>position</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div>
<div class="memdoc">
<p>FunctionName:getdepartmentAllRow Description: 获取数据库按小区排序的所有列数 </p>
<dl class="return"><dt><b>返回:</b></dt><dd>列数 </dd></dl>

<p>在文件<a class="el" href="sql_man_8java_source.html">sqlMan.java</a>第<a class="el" href="sql_man_8java_source.html#l00277">277</a>行定义。</p>

<p>参考 <a class="el" href="_data_base_helper_8java_source.html#l00312">com.zxx.sql.DataBaseHelper.getDepartmentRest()</a>及<a class="el" href="_data_base_helper_8java_source.html#l00303">com.zxx.sql.DataBaseHelper.getSortListRest()</a>.</p>

<p><div class="dynheader">
函数调用图:</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1sql_man_a18d6c85da0f0fd72cddd38bed00f6b83_cgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1sql_man_a18d6c85da0f0fd72cddd38bed00f6b83_cgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1sql_man_a18d6c85da0f0fd72cddd38bed00f6b83_cgraph" id="classcom_1_1zxx_1_1sql_1_1sql_man_a18d6c85da0f0fd72cddd38bed00f6b83_cgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a4ad07dffcd6eafdcd227136f6d1bf6d8" title="获取区域剩余项目" alt="" coords="399,5,796,37"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ac07978f4e7858ba1fdc4ee3cf70b38c1" title="获取列表剩余项目" alt="" coords="415,61,780,93"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ac5fa833c7831d807f81ac6044ccfeb43" title="获取数据库按sql语句拼接后查询的总列数" alt="" coords="847,33,1199,65"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a5e18d0bd4b1170a043a4b43f32f651f7"></a><!-- doxytag: member="com::zxx::sql::sqlMan::getHouseTypeRow" ref="a5e18d0bd4b1170a043a4b43f32f651f7" args="(int position)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int <a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a5e18d0bd4b1170a043a4b43f32f651f7">com.zxx.sql.sqlMan.getHouseTypeRow</a> </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>position</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div>
<div class="memdoc">
<p>FunctionName:getHouseTypeRow Description: 获取按房子类型的剩余屋子总数 </p>
<dl class="params"><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">position</td><td>列表上选择的position </td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="sql_man_8java_source.html">sqlMan.java</a>第<a class="el" href="sql_man_8java_source.html#l00329">329</a>行定义。</p>

<p>参考 <a class="el" href="_data_base_helper_8java_source.html#l00344">com.zxx.sql.DataBaseHelper.getHouseTypeRest()</a>.</p>

<p><div class="dynheader">
函数调用图:</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1sql_man_a5e18d0bd4b1170a043a4b43f32f651f7_cgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1sql_man_a5e18d0bd4b1170a043a4b43f32f651f7_cgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1sql_man_a5e18d0bd4b1170a043a4b43f32f651f7_cgraph" id="classcom_1_1zxx_1_1sql_1_1sql_man_a5e18d0bd4b1170a043a4b43f32f651f7_cgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a97a296a026ae1dffff131cdf5e3b5575" title="获取按房子类型的剩余屋子总数" alt="" coords="379,5,776,37"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ac5fa833c7831d807f81ac6044ccfeb43" title="获取数据库按sql语句拼接后查询的总列数" alt="" coords="825,5,1177,37"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a51310f84ffa54239860ee1edb78bc8da"></a><!-- doxytag: member="com::zxx::sql::sqlMan::getPmPriceAllrow" ref="a51310f84ffa54239860ee1edb78bc8da" args="(int position)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int <a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a51310f84ffa54239860ee1edb78bc8da">com.zxx.sql.sqlMan.getPmPriceAllrow</a> </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>position</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div>
<div class="memdoc">
<p>Description: 获取按房子单价的剩余屋子总数 </p>
<dl class="params"><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">position</td><td>列表上选择的position </td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="sql_man_8java_source.html">sqlMan.java</a>第<a class="el" href="sql_man_8java_source.html#l00354">354</a>行定义。</p>

<p>参考 <a class="el" href="_data_base_helper_8java_source.html#l00369">com.zxx.sql.DataBaseHelper.getPmPrice1W_2W()</a>、<a class="el" href="_data_base_helper_8java_source.html#l00376">com.zxx.sql.DataBaseHelper.getPmPriceabove2W()</a>、<a class="el" href="_data_base_helper_8java_source.html#l00362">com.zxx.sql.DataBaseHelper.getPmPriceBELOW1W()</a>及<a class="el" href="_data_base_helper_8java_source.html#l00303">com.zxx.sql.DataBaseHelper.getSortListRest()</a>.</p>

<p><div class="dynheader">
函数调用图:</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1sql_man_a51310f84ffa54239860ee1edb78bc8da_cgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1sql_man_a51310f84ffa54239860ee1edb78bc8da_cgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1sql_man_a51310f84ffa54239860ee1edb78bc8da_cgraph" id="classcom_1_1zxx_1_1sql_1_1sql_man_a51310f84ffa54239860ee1edb78bc8da_cgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ad9f82a031e22b1c73f1ee42bf39aa803" title="获取单价剩余项目(1W_2W之间)" alt="" coords="381,5,781,37"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a83b37eb5a06585c21f6343622bcb19ed" title="获取单价剩余项目(大于2Ｗ)" alt="" coords="376,61,787,93"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a8049b88898ba4ac2d5f419cd3acf3e92" title="获取单价剩余项目(小于1W)" alt="" coords="368,117,795,149"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ac07978f4e7858ba1fdc4ee3cf70b38c1" title="获取列表剩余项目" alt="" coords="399,173,764,205"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ac5fa833c7831d807f81ac6044ccfeb43" title="获取数据库按sql语句拼接后查询的总列数" alt="" coords="844,89,1196,121"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a4de4fb93998425200bce9ac7d8d94385"></a><!-- doxytag: member="com::zxx::sql::sqlMan::getSqlAllRow" ref="a4de4fb93998425200bce9ac7d8d94385" args="()" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int <a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a4de4fb93998425200bce9ac7d8d94385">com.zxx.sql.sqlMan.getSqlAllRow</a> </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div>
<div class="memdoc">
<p>FunctionName:getSqlAllRow Description: 获取数据库默认排序的所有列数 </p>
<dl class="return"><dt><b>返回:</b></dt><dd>列数 </dd></dl>

<p>在文件<a class="el" href="sql_man_8java_source.html">sqlMan.java</a>第<a class="el" href="sql_man_8java_source.html#l00269">269</a>行定义。</p>

<p>参考 <a class="el" href="_data_base_helper_8java_source.html#l00303">com.zxx.sql.DataBaseHelper.getSortListRest()</a>.</p>

<p><div class="dynheader">
函数调用图:</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1sql_man_a4de4fb93998425200bce9ac7d8d94385_cgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1sql_man_a4de4fb93998425200bce9ac7d8d94385_cgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1sql_man_a4de4fb93998425200bce9ac7d8d94385_cgraph" id="classcom_1_1zxx_1_1sql_1_1sql_man_a4de4fb93998425200bce9ac7d8d94385_cgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ac07978f4e7858ba1fdc4ee3cf70b38c1" title="获取列表剩余项目" alt="" coords="335,5,700,37"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ac5fa833c7831d807f81ac6044ccfeb43" title="获取数据库按sql语句拼接后查询的总列数" alt="" coords="751,5,1103,37"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a36d1520cc83a606111323bf4ae1b6c01"></a><!-- doxytag: member="com::zxx::sql::sqlMan::getTotalPriceAllrow" ref="a36d1520cc83a606111323bf4ae1b6c01" args="(int position)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int <a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a36d1520cc83a606111323bf4ae1b6c01">com.zxx.sql.sqlMan.getTotalPriceAllrow</a> </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>position</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div>
<div class="memdoc">
<p>FunctionName:getTotalPriceAllrow Description: 获取数据库按单价选择后的所有列数 </p>
<dl class="return"><dt><b>返回:</b></dt><dd>列数 </dd></dl>

<p>在文件<a class="el" href="sql_man_8java_source.html">sqlMan.java</a>第<a class="el" href="sql_man_8java_source.html#l00292">292</a>行定义。</p>

<p>参考 <a class="el" href="_data_base_helper_8java_source.html#l00303">com.zxx.sql.DataBaseHelper.getSortListRest()</a>、<a class="el" href="_data_base_helper_8java_source.html#l00327">com.zxx.sql.DataBaseHelper.getTotalPrice100W_200W()</a>、<a class="el" href="_data_base_helper_8java_source.html#l00334">com.zxx.sql.DataBaseHelper.getTotalPriceabove200W()</a>及<a class="el" href="_data_base_helper_8java_source.html#l00320">com.zxx.sql.DataBaseHelper.getTotalPricebelow100W()</a>.</p>

<p><div class="dynheader">
函数调用图:</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1sql_man_a36d1520cc83a606111323bf4ae1b6c01_cgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1sql_man_a36d1520cc83a606111323bf4ae1b6c01_cgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1sql_man_a36d1520cc83a606111323bf4ae1b6c01_cgraph" id="classcom_1_1zxx_1_1sql_1_1sql_man_a36d1520cc83a606111323bf4ae1b6c01_cgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ac07978f4e7858ba1fdc4ee3cf70b38c1" title="获取列表剩余项目" alt="" coords="424,5,789,37"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a1a573af5e5dc2e3da464db8306ac202f" title="获取总价格剩余项目(100W_200W之间)" alt="" coords="381,61,832,93"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ac8d51264dab4db042d6fc81f31b7a67b" title="获取总价格剩余项目(大于200Ｗ)" alt="" coords="385,117,828,149"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a8c36701e1a6550ae6e9c9fd212118cd2" title="获取总价格剩余项目(小于100W)" alt="" coords="387,173,827,205"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ac5fa833c7831d807f81ac6044ccfeb43" title="获取数据库按sql语句拼接后查询的总列数" alt="" coords="881,89,1233,121"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="adb9f43d7a23c7db4adc2978b96c7feda"></a><!-- doxytag: member="com::zxx::sql::sqlMan::getZXTypeRow" ref="adb9f43d7a23c7db4adc2978b96c7feda" args="(int position)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int <a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#adb9f43d7a23c7db4adc2978b96c7feda">com.zxx.sql.sqlMan.getZXTypeRow</a> </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>position</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div>
<div class="memdoc">
<p>FunctionName:getZXTypeRow Description: 获取按装修类型的剩余屋子总数 </p>
<dl class="params"><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">position</td><td>列表上选择的position </td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="sql_man_8java_source.html">sqlMan.java</a>第<a class="el" href="sql_man_8java_source.html#l00341">341</a>行定义。</p>

<p>参考 <a class="el" href="_data_base_helper_8java_source.html#l00354">com.zxx.sql.DataBaseHelper.getZXTypeRest()</a>.</p>

<p><div class="dynheader">
函数调用图:</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1sql_man_adb9f43d7a23c7db4adc2978b96c7feda_cgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1sql_man_adb9f43d7a23c7db4adc2978b96c7feda_cgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1sql_man_adb9f43d7a23c7db4adc2978b96c7feda_cgraph" id="classcom_1_1zxx_1_1sql_1_1sql_man_adb9f43d7a23c7db4adc2978b96c7feda_cgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a09d0383cf37d1e8b86acb34b447e97b4" title="获取按装修类型的房子剩余总数" alt="" coords="353,5,721,37"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ac5fa833c7831d807f81ac6044ccfeb43" title="获取数据库按sql语句拼接后查询的总列数" alt="" coords="772,5,1124,37"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="ade630bd22dc7fdafbcb853061b6912f1"></a><!-- doxytag: member="com::zxx::sql::sqlMan::insertData" ref="ade630bd22dc7fdafbcb853061b6912f1" args="()" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">long <a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#ade630bd22dc7fdafbcb853061b6912f1">com.zxx.sql.sqlMan.insertData</a> </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div>
<div class="memdoc">
<p>Description:从assert文件夹的excel文件读取数据并插入数据库 </p>
<dl class="return"><dt><b>返回:</b></dt><dd>0 成功，-1 失败 </dd></dl>

<p>在文件<a class="el" href="sql_man_8java_source.html">sqlMan.java</a>第<a class="el" href="sql_man_8java_source.html#l00066">66</a>行定义。</p>

<p>参考 <a class="el" href="_data_base_helper_8java_source.html#l00067">com.zxx.sql.DataBaseHelper.insertData()</a>及<a class="el" href="_data_base_helper_8java_source.html#l00289">com.zxx.sql.DataBaseHelper.selectRepeatData()</a>.</p>

<p><div class="dynheader">
函数调用图:</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1sql_man_ade630bd22dc7fdafbcb853061b6912f1_cgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1sql_man_ade630bd22dc7fdafbcb853061b6912f1_cgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1sql_man_ade630bd22dc7fdafbcb853061b6912f1_cgraph" id="classcom_1_1zxx_1_1sql_1_1sql_man_ade630bd22dc7fdafbcb853061b6912f1_cgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a142d88439400d7dcff3ca070cd0fca54" title="建立数据表" alt="" coords="339,5,667,37"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a64cc784e2906df5e67508069246f91c7" title="查询数据库是不是有重复数据" alt="" coords="309,61,696,93"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a51e1619f15f11234a9b2f2e5d45138d9"></a><!-- doxytag: member="com::zxx::sql::sqlMan::selectSQLByDepart" ref="a51e1619f15f11234a9b2f2e5d45138d9" args="(int position, int limitindex, int limitnum)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">ArrayList&lt;<a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a>&gt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a51e1619f15f11234a9b2f2e5d45138d9">com.zxx.sql.sqlMan.selectSQLByDepart</a> </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>position</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitindex</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitnum</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div>
<div class="memdoc">
<p>Description:按小区选择数据库 </p>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="sql_man_8java_source.html">sqlMan.java</a>第<a class="el" href="sql_man_8java_source.html#l00135">135</a>行定义。</p>

<p>参考 <a class="el" href="_data_base_helper_8java_source.html#l00105">com.zxx.sql.DataBaseHelper.select_byDepart()</a>.</p>

<p><div class="dynheader">
函数调用图:</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1sql_man_a51e1619f15f11234a9b2f2e5d45138d9_cgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1sql_man_a51e1619f15f11234a9b2f2e5d45138d9_cgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1sql_man_a51e1619f15f11234a9b2f2e5d45138d9_cgraph" id="classcom_1_1zxx_1_1sql_1_1sql_man_a51e1619f15f11234a9b2f2e5d45138d9_cgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a1ba2df090cac74b2a3281f0df8d8b6ce" title="按小区选择" alt="" coords="384,5,757,37"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a244e424a6144e30e6fb02544ac12fef1" title="获取数据库按sql语句拼接后查询结果" alt="" coords="805,5,1133,37"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a2a509c26769e627d0aab9adadc276ee1"></a><!-- doxytag: member="com::zxx::sql::sqlMan::selectSQLByHouseType" ref="a2a509c26769e627d0aab9adadc276ee1" args="(int position, int limitindex, int limitnum)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">ArrayList&lt;<a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a>&gt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a2a509c26769e627d0aab9adadc276ee1">com.zxx.sql.sqlMan.selectSQLByHouseType</a> </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>position</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitindex</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitnum</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div>
<div class="memdoc">
<p>Description:按户型选择数据库 </p>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="sql_man_8java_source.html">sqlMan.java</a>第<a class="el" href="sql_man_8java_source.html#l00174">174</a>行定义。</p>

</div>
</div>
<a class="anchor" id="aaba0ff9f406a4804784aed9e4f97a811"></a><!-- doxytag: member="com::zxx::sql::sqlMan::selectSQLByPmPrice" ref="aaba0ff9f406a4804784aed9e4f97a811" args="(int position, int limitindex, int limitnum)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">ArrayList&lt;<a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a>&gt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#aaba0ff9f406a4804784aed9e4f97a811">com.zxx.sql.sqlMan.selectSQLByPmPrice</a> </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>position</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitindex</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitnum</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div>
<div class="memdoc">
<p>Description:按单价选择数据库 </p>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="sql_man_8java_source.html">sqlMan.java</a>第<a class="el" href="sql_man_8java_source.html#l00193">193</a>行定义。</p>

<p>参考 <a class="el" href="_data_base_helper_8java_source.html#l00174">com.zxx.sql.DataBaseHelper.select_byPmPriceabove2W()</a>、<a class="el" href="_data_base_helper_8java_source.html#l00163">com.zxx.sql.DataBaseHelper.select_byPmPricebelow1W()</a>及<a class="el" href="_data_base_helper_8java_source.html#l00185">com.zxx.sql.DataBaseHelper.select_byPricebetween1w_2w()</a>.</p>

<p><div class="dynheader">
函数调用图:</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1sql_man_aaba0ff9f406a4804784aed9e4f97a811_cgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1sql_man_aaba0ff9f406a4804784aed9e4f97a811_cgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1sql_man_aaba0ff9f406a4804784aed9e4f97a811_cgraph" id="classcom_1_1zxx_1_1sql_1_1sql_man_aaba0ff9f406a4804784aed9e4f97a811_cgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#ae337350f3219c2a9a30488389cb30a07" title="选取数据库中单价在2Ｗ上的房子" alt="" coords="409,5,868,37"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a5a7ecb58ce31d571efa6232cdff0332a" title="选取数据库中单价小于1W的房子" alt="" coords="409,61,868,93"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a9a3df95a83eba8230a03bfcd91d62620" title="选取数据库中单价在1Ｗ——2W之间的房子" alt="" coords="399,117,879,149"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a244e424a6144e30e6fb02544ac12fef1" title="获取数据库按sql语句拼接后查询结果" alt="" coords="928,61,1256,93"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a08637e16cd1a288c8bb8ce20ca83e8dc"></a><!-- doxytag: member="com::zxx::sql::sqlMan::selectSQLByTotalPrice" ref="a08637e16cd1a288c8bb8ce20ca83e8dc" args="(int position, int limitindex, int limitnum)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">ArrayList&lt;<a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a>&gt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a08637e16cd1a288c8bb8ce20ca83e8dc">com.zxx.sql.sqlMan.selectSQLByTotalPrice</a> </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>position</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitindex</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitnum</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div>
<div class="memdoc">
<p>Description:按总价选择数据库 </p>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="sql_man_8java_source.html">sqlMan.java</a>第<a class="el" href="sql_man_8java_source.html#l00149">149</a>行定义。</p>

<p>参考 <a class="el" href="_data_base_helper_8java_source.html#l00130">com.zxx.sql.DataBaseHelper.select_byTotalPriceabove200W()</a>、<a class="el" href="_data_base_helper_8java_source.html#l00120">com.zxx.sql.DataBaseHelper.select_byTotalPricebelow100W()</a>及<a class="el" href="_data_base_helper_8java_source.html#l00141">com.zxx.sql.DataBaseHelper.select_byTotalPricebetween100_200()</a>.</p>

<p><div class="dynheader">
函数调用图:</div>
<div class="dyncontent">
<div class="center"><img src="classcom_1_1zxx_1_1sql_1_1sql_man_a08637e16cd1a288c8bb8ce20ca83e8dc_cgraph.png" border="0" usemap="#classcom_1_1zxx_1_1sql_1_1sql_man_a08637e16cd1a288c8bb8ce20ca83e8dc_cgraph" alt=""/></div>
<map name="classcom_1_1zxx_1_1sql_1_1sql_man_a08637e16cd1a288c8bb8ce20ca83e8dc_cgraph" id="classcom_1_1zxx_1_1sql_1_1sql_man_a08637e16cd1a288c8bb8ce20ca83e8dc_cgraph">
<area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a738880bd8d0083701bbbd655af857b3c" title="选取数据库中总价在200Ｗ上的房子" alt="" coords="432,5,923,37"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a4d00facfe50abf683dc52b21f777a067" title="选取数据库中总价在100Ｗ下的房子" alt="" coords="432,61,923,93"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#aac7ea38dc71810971006c13cc3af3f90" title="选取数据库中总价在100Ｗ——200W之间的房子" alt="" coords="411,117,944,149"/><area shape="rect" href="classcom_1_1zxx_1_1sql_1_1_data_base_helper.html#a244e424a6144e30e6fb02544ac12fef1" title="获取数据库按sql语句拼接后查询结果" alt="" coords="992,61,1320,93"/></map>
</div>
</p>

</div>
</div>
<a class="anchor" id="a566400e53b2720115f33ef00dfafba4a"></a><!-- doxytag: member="com::zxx::sql::sqlMan::selectSQLByZX" ref="a566400e53b2720115f33ef00dfafba4a" args="(int position, int limitindex, int limitnum)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">ArrayList&lt;<a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a>&gt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a566400e53b2720115f33ef00dfafba4a">com.zxx.sql.sqlMan.selectSQLByZX</a> </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>position</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitindex</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitnum</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div>
<div class="memdoc">
<p>Description:按装修类型选择数据库 </p>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="sql_man_8java_source.html">sqlMan.java</a>第<a class="el" href="sql_man_8java_source.html#l00183">183</a>行定义。</p>

</div>
</div>
<a class="anchor" id="a8220ec6e98f7f681a9e6002367fe780d"></a><!-- doxytag: member="com::zxx::sql::sqlMan::selectSQLDefault" ref="a8220ec6e98f7f681a9e6002367fe780d" args="(int limitindex, int limitnum)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">ArrayList&lt;<a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a>&gt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a8220ec6e98f7f681a9e6002367fe780d">com.zxx.sql.sqlMan.selectSQLDefault</a> </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitindex</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitnum</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div>
<div class="memdoc">
<p>Description:按默认模式选择数据库 </p>
<dl class="return"><dt><b>返回:</b></dt><dd>数据库数据列表 </dd></dl>

<p>在文件<a class="el" href="sql_man_8java_source.html">sqlMan.java</a>第<a class="el" href="sql_man_8java_source.html#l00127">127</a>行定义。</p>

</div>
</div>
<a class="anchor" id="af8278ce8bab519ebb5d6e909edbfa2cd"></a><!-- doxytag: member="com::zxx::sql::sqlMan::sort_byAreaH_L" ref="af8278ce8bab519ebb5d6e909edbfa2cd" args="(int limitindex, int limitnum)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">ArrayList&lt;<a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a>&gt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#af8278ce8bab519ebb5d6e909edbfa2cd">com.zxx.sql.sqlMan.sort_byAreaH_L</a> </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitindex</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitnum</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div>
<div class="memdoc">
<p>FunctionName:sort_byAreaH_L Description: 按面积由高到低排序数据库 </p>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="sql_man_8java_source.html">sqlMan.java</a>第<a class="el" href="sql_man_8java_source.html#l00260">260</a>行定义。</p>

</div>
</div>
<a class="anchor" id="ace45dff4a0544e8a24d0ca121ec369d0"></a><!-- doxytag: member="com::zxx::sql::sqlMan::sort_byAreaL_H" ref="ace45dff4a0544e8a24d0ca121ec369d0" args="(int limitindex, int limitnum)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">ArrayList&lt;<a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a>&gt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#ace45dff4a0544e8a24d0ca121ec369d0">com.zxx.sql.sqlMan.sort_byAreaL_H</a> </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitindex</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitnum</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div>
<div class="memdoc">
<p>FunctionName:sort_byAreaL_H Description: 按面积由低到高排序数据库 </p>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="sql_man_8java_source.html">sqlMan.java</a>第<a class="el" href="sql_man_8java_source.html#l00251">251</a>行定义。</p>

</div>
</div>
<a class="anchor" id="ac4fc3535f12fcbdcfd091f6ca9b7dd1c"></a><!-- doxytag: member="com::zxx::sql::sqlMan::sort_byPriceH_L" ref="ac4fc3535f12fcbdcfd091f6ca9b7dd1c" args="(int limitindex, int limitnum)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">ArrayList&lt;<a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a>&gt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#ac4fc3535f12fcbdcfd091f6ca9b7dd1c">com.zxx.sql.sqlMan.sort_byPriceH_L</a> </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitindex</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitnum</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div>
<div class="memdoc">
<p>Description:按单价由高到低排序数据库 </p>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="sql_man_8java_source.html">sqlMan.java</a>第<a class="el" href="sql_man_8java_source.html#l00215">215</a>行定义。</p>

</div>
</div>
<a class="anchor" id="a90b2775363d92c63bdc6a25f7fb13ace"></a><!-- doxytag: member="com::zxx::sql::sqlMan::sort_byPriceL_H" ref="a90b2775363d92c63bdc6a25f7fb13ace" args="(int limitindex, int limitnum)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">ArrayList&lt;<a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a>&gt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a90b2775363d92c63bdc6a25f7fb13ace">com.zxx.sql.sqlMan.sort_byPriceL_H</a> </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitindex</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitnum</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div>
<div class="memdoc">
<p>FunctionName:sort_byPriceL_H Description: 按单价由低到高排序数据库 </p>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="sql_man_8java_source.html">sqlMan.java</a>第<a class="el" href="sql_man_8java_source.html#l00224">224</a>行定义。</p>

</div>
</div>
<a class="anchor" id="a5c98369ec30fdd33c1c3ba3b53e20bbb"></a><!-- doxytag: member="com::zxx::sql::sqlMan::sort_byYearH_L" ref="a5c98369ec30fdd33c1c3ba3b53e20bbb" args="(int limitindex, int limitnum)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">ArrayList&lt;<a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a>&gt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a5c98369ec30fdd33c1c3ba3b53e20bbb">com.zxx.sql.sqlMan.sort_byYearH_L</a> </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitindex</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitnum</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div>
<div class="memdoc">
<p>FunctionName:sort_byYearH_L Description: 按年份由高到低排序数据库 </p>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="sql_man_8java_source.html">sqlMan.java</a>第<a class="el" href="sql_man_8java_source.html#l00233">233</a>行定义。</p>

</div>
</div>
<a class="anchor" id="a96e48378ca51ca141c468c29c5b12223"></a><!-- doxytag: member="com::zxx::sql::sqlMan::sort_byYearL_H" ref="a96e48378ca51ca141c468c29c5b12223" args="(int limitindex, int limitnum)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">ArrayList&lt;<a class="el" href="classcom_1_1zxx_1_1sql_1_1house_data.html">houseData</a>&gt; <a class="el" href="classcom_1_1zxx_1_1sql_1_1sql_man.html#a96e48378ca51ca141c468c29c5b12223">com.zxx.sql.sqlMan.sort_byYearL_H</a> </td>
          <td>(</td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitindex</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>limitnum</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div>
<div class="memdoc">
<p>FunctionName:sort_byYearL_H Description: 按年份由低到高排序数据库 </p>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

<p>在文件<a class="el" href="sql_man_8java_source.html">sqlMan.java</a>第<a class="el" href="sql_man_8java_source.html#l00242">242</a>行定义。</p>

</div>
</div>
<hr/>该类的文档由以下文件生成：<ul>
<li>src/com/zxx/sql/<a class="el" href="sql_man_8java_source.html">sqlMan.java</a></li>
</ul>
</div><!-- contents -->


<hr class="footer"/><address class="footer"><small>
Generated at 2015年二月4日 星期三 18:11:10 for zxxhouse by &#160;<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/>
</a> 1.7.6.1
</small></address>

</body>
</html>
